﻿IF object_id(N'dbo.TabExtMailSetting', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[TabExtMailSetting] (
        [ID]             int          NOT NULL identity(1, 1),
        [Username]       nvarchar(50)  COLLATE Chinese_PRC_CI_AS NOT NULL,
        [Title]          nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [Email]          nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL,
        [SmtpAuth]       bit          NULL,
        [SmtpServer]     nvarchar(64)  COLLATE Chinese_PRC_CI_AS NULL,
        [SmtpUsername]   nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
        [SmtpPassword]   nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
        [SmtpPort]       smallint     NULL,
        [PopServer]      nvarchar(64)  COLLATE Chinese_PRC_CI_AS NULL,
        [PopUsername]    nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
        [PopPassword]    nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
        [PopPort]        smallint     NULL,
        [IsDelAfterRead] bit          NULL,
        [IsReceiveNew]   bit          NULL,
        [TimeOut]        nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [OrderID]        int          NULL
    );
END
GO
